Overview

Brought to you by YData

Dataset statistics

Number of variables	44
Number of observations	119143
Missing cells	211772
Missing cells (%)	4.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	228.0 MiB
Average record size in memory	2.0 KiB

Variable types

Text	13
Categorical	6
DateTime	8
Numeric	17

Alerts

`customer_state` is highly overall correlated with `customer_zip_code_prefix`	High correlation
`customer_zip_code_prefix` is highly overall correlated with `customer_state`	High correlation
`geolocation_lat` is highly overall correlated with `geolocation_state` and 1 other fields	High correlation
`geolocation_lng` is highly overall correlated with `geolocation_state` and 1 other fields	High correlation
`geolocation_state` is highly overall correlated with `geolocation_lat` and 3 other fields	High correlation
`payment_value` is highly overall correlated with `price`	High correlation
`price` is highly overall correlated with `payment_value` and 1 other fields	High correlation
`product_height_cm` is highly overall correlated with `product_weight_g`	High correlation
`product_length_cm` is highly overall correlated with `product_weight_g` and 1 other fields	High correlation
`product_weight_g` is highly overall correlated with `price` and 3 other fields	High correlation
`product_width_cm` is highly overall correlated with `product_length_cm` and 1 other fields	High correlation
`seller_state` is highly overall correlated with `geolocation_lat` and 3 other fields	High correlation
`zip_code_prefix` is highly overall correlated with `geolocation_state` and 1 other fields	High correlation
`order_status` is highly imbalanced (91.6%)	Imbalance
`payment_type` is highly imbalanced (52.6%)	Imbalance
`seller_state` is highly imbalanced (63.3%)	Imbalance
`geolocation_state` is highly imbalanced (62.3%)	Imbalance
`order_delivered_carrier_date` has 2086 (1.8%) missing values	Missing
`order_delivered_customer_date` has 3421 (2.9%) missing values	Missing
`review_comment_title` has 105154 (88.3%) missing values	Missing
`review_comment_message` has 68898 (57.8%) missing values	Missing
`product_category_name` has 2542 (2.1%) missing values	Missing
`product_name_lenght` has 2542 (2.1%) missing values	Missing
`product_description_lenght` has 2542 (2.1%) missing values	Missing
`product_photos_qty` has 2542 (2.1%) missing values	Missing
`product_category_name_english` has 2567 (2.2%) missing values	Missing

Reproduction

Analysis started	2025-07-05 23:22:31.531273
Analysis finished	2025-07-05 23:24:03.199030
Duration	1 minute and 31.67 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

order_id
Text

Distinct	99441
Distinct (%)	83.5%
Missing	0
Missing (%)	0.0%
Memory size	10.1 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3812576
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	86494 ?
Unique (%)	72.6%

Sample

1st row	e481f51cbdc54678b7cc49136f2d6af7
2nd row	e481f51cbdc54678b7cc49136f2d6af7
3rd row	e481f51cbdc54678b7cc49136f2d6af7
4th row	53cdb2fc8bc7dce0b6741e2150273451
5th row	47770eb9100c2d0c44946d9cf07ec65d

Value	Count	Frequency (%)
895ab968e7bb0d5659d16cd74cd1650c	63	0.1%
fedcd9f7ccdc8cba3a18defedd1a5547	38	< 0.1%
fa65dad1b0e818e3ccc5cb0e39231352	29	< 0.1%
ccf804e764ed5650cd8759557269dc13	26	< 0.1%
c6492b842ac190db807c15aff21a7dd6	24	< 0.1%
6d58638e32674bebee793a47ac4cbadc	24	< 0.1%
465c2e1bee4561cb39e0db8c5993aafc	24	< 0.1%
68986e4324f6a21481df4e6e89abcf01	24	< 0.1%
a3725dfe487d359b5be08cac48b64ec5	24	< 0.1%
285c2e15bebd4ac83635ccc563dc71f4	22	< 0.1%
Other values (99431)	118845	99.7%

Most occurring characters

Value	Count	Frequency (%)
4	239371	6.3%
b	239344	6.3%
6	239250	6.3%
e	238956	6.3%
3	238724	6.3%
c	238563	6.3%
8	238518	6.3%
7	238501	6.3%
1	238422	6.3%
a	238162	6.2%
Other values (6)	1424765	37.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3812576	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	239371	6.3%
b	239344	6.3%
6	239250	6.3%
e	238956	6.3%
3	238724	6.3%
c	238563	6.3%
8	238518	6.3%
7	238501	6.3%
1	238422	6.3%
a	238162	6.2%
Other values (6)	1424765	37.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3812576	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	239371	6.3%
b	239344	6.3%
6	239250	6.3%
e	238956	6.3%
3	238724	6.3%
c	238563	6.3%
8	238518	6.3%
7	238501	6.3%
1	238422	6.3%
a	238162	6.2%
Other values (6)	1424765	37.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3812576	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	239371	6.3%
b	239344	6.3%
6	239250	6.3%
e	238956	6.3%
3	238724	6.3%
c	238563	6.3%
8	238518	6.3%
7	238501	6.3%
1	238422	6.3%
a	238162	6.2%
Other values (6)	1424765	37.4%

customer_id
Text

Distinct	99441
Distinct (%)	83.5%
Missing	0
Missing (%)	0.0%
Memory size	10.1 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3812576
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	86494 ?
Unique (%)	72.6%

Sample

1st row	9ef432eb6251297304e76186b10a928d
2nd row	9ef432eb6251297304e76186b10a928d
3rd row	9ef432eb6251297304e76186b10a928d
4th row	b0830fb4747a6c6d20dea0b8c802d7ef
5th row	41ce2a54c0b03bf3443c3d931a367089

Value	Count	Frequency (%)
270c23a11d024a44c896d1894b261a83	63	0.1%
13aa59158da63ba0e93ec6ac2c07aacb	38	< 0.1%
9af2372a1e49340278e7c1ef8d749f34	29	< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e2	26	< 0.1%
6ee2f17e3b6c33d6a9557f280edd2925	24	< 0.1%
2ba91e12e5e4c9f56b82b86d9031d329	24	< 0.1%
63b964e79dee32a3587651701a2b8dbf	24	< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb	24	< 0.1%
d22f25a9fadfb1abbc2e29395b1239f4	24	< 0.1%
b246eeed30b362c09d867b9e598bee51	22	< 0.1%
Other values (99431)	118845	99.7%

Most occurring characters

Value	Count	Frequency (%)
f	239014	6.3%
2	238989	6.3%
5	238748	6.3%
c	238647	6.3%
6	238555	6.3%
1	238489	6.3%
8	238361	6.3%
d	238357	6.3%
7	238270	6.2%
a	238267	6.2%
Other values (6)	1426879	37.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3812576	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
f	239014	6.3%
2	238989	6.3%
5	238748	6.3%
c	238647	6.3%
6	238555	6.3%
1	238489	6.3%
8	238361	6.3%
d	238357	6.3%
7	238270	6.2%
a	238267	6.2%
Other values (6)	1426879	37.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3812576	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
f	239014	6.3%
2	238989	6.3%
5	238748	6.3%
c	238647	6.3%
6	238555	6.3%
1	238489	6.3%
8	238361	6.3%
d	238357	6.3%
7	238270	6.2%
a	238267	6.2%
Other values (6)	1426879	37.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3812576	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
f	239014	6.3%
2	238989	6.3%
5	238748	6.3%
c	238647	6.3%
6	238555	6.3%
1	238489	6.3%
8	238361	6.3%
d	238357	6.3%
7	238270	6.2%
a	238267	6.2%
Other values (6)	1426879	37.4%

order_status
Categorical

Imbalance

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

delivered	115723
shipped	1256
canceled	750
unavailable	652
invoiced	378
Other values (3)	384

Length

Max length	11
Median length	9
Mean length	8.9834401
Min length	7

Characters and Unicode

Total characters	1070314
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	delivered
2nd row	delivered
3rd row	delivered
4th row	delivered
5th row	delivered

Common Values

Value	Count	Frequency (%)
delivered	115723	97.1%
shipped	1256	1.1%
canceled	750	0.6%
unavailable	652	0.5%
invoiced	378	0.3%
processing	376	0.3%
created	5	< 0.1%
approved	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
delivered	115723	97.1%
shipped	1256	1.1%
canceled	750	0.6%
unavailable	652	0.5%
invoiced	378	0.3%
processing	376	0.3%
created	5	< 0.1%
approved	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	351344	32.8%
d	233838	21.8%
i	118763	11.1%
l	117777	11.0%
v	116756	10.9%
r	116107	10.8%
p	2894	0.3%
a	2714	0.3%
c	2259	0.2%
n	2156	0.2%
Other values (7)	5706	0.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1070314	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	351344	32.8%
d	233838	21.8%
i	118763	11.1%
l	117777	11.0%
v	116756	10.9%
r	116107	10.8%
p	2894	0.3%
a	2714	0.3%
c	2259	0.2%
n	2156	0.2%
Other values (7)	5706	0.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1070314	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	351344	32.8%
d	233838	21.8%
i	118763	11.1%
l	117777	11.0%
v	116756	10.9%
r	116107	10.8%
p	2894	0.3%
a	2714	0.3%
c	2259	0.2%
n	2156	0.2%
Other values (7)	5706	0.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1070314	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	351344	32.8%
d	233838	21.8%
i	118763	11.1%
l	117777	11.0%
v	116756	10.9%
r	116107	10.8%
p	2894	0.3%
a	2714	0.3%
c	2259	0.2%
n	2156	0.2%
Other values (7)	5706	0.5%

order_purchase_timestamp
Date

Distinct	98875
Distinct (%)	83.0%
Missing	0
Missing (%)	0.0%
Memory size	930.9 KiB

Minimum	2016-09-04 21:15:19
Maximum	2018-10-17 17:30:18
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_approved_at
Date

Distinct	90733
Distinct (%)	76.3%
Missing	177
Missing (%)	0.1%
Memory size	930.9 KiB

Minimum	2016-09-15 12:16:38
Maximum	2018-09-03 17:40:06
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_delivered_carrier_date
Date

Missing

Distinct	81018
Distinct (%)	69.2%
Missing	2086
Missing (%)	1.8%
Memory size	930.9 KiB

Minimum	2016-10-08 10:34:01
Maximum	2018-09-11 19:48:28
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_delivered_customer_date
Date

Missing

Distinct	95664
Distinct (%)	82.7%
Missing	3421
Missing (%)	2.9%
Memory size	930.9 KiB

Minimum	2016-10-11 13:46:32
Maximum	2018-10-17 13:22:46
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_estimated_delivery_date
Date

Distinct	459
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	930.9 KiB

Minimum	2016-09-30 00:00:00
Maximum	2018-11-12 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

customer_unique_id
Text

Distinct	96096
Distinct (%)	80.7%
Missing	0
Missing (%)	0.0%
Memory size	10.1 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3812576
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	81601 ?
Unique (%)	68.5%

Sample

1st row	7c396fd4830fd04220f754e42b4e5bff
2nd row	7c396fd4830fd04220f754e42b4e5bff
3rd row	7c396fd4830fd04220f754e42b4e5bff
4th row	af07308b275d755c9edb36a90c618231
5th row	3a653a41f6f9fc3d2a113cf8398680e8

Value	Count	Frequency (%)
9a736b248f67d166d2fbb006bcb877c3	75	0.1%
6fbc7cdadbb522125f4b27ae9dee4060	38	< 0.1%
f9ae226291893fda10af7965268fb7f6	35	< 0.1%
8af7ac63b2efbcbd88e5b11505e8098a	29	< 0.1%
569aa12b73b5f7edeaa6f2a01603e381	26	< 0.1%
d97b3cfb22b0d6b25ac9ed4e9c2d481b	24	< 0.1%
5419a7c9b86a43d8140e2939cd2c2f7e	24	< 0.1%
db1af3fd6b23ac3873ef02619d548f9c	24	< 0.1%
c8460e4251689ba205045f3ea17884a1	24	< 0.1%
85963fd37bfd387aa6d915d8a1065486	24	< 0.1%
Other values (96086)	118820	99.7%

Most occurring characters

Value	Count	Frequency (%)
6	239302	6.3%
b	238901	6.3%
1	238720	6.3%
a	238717	6.3%
d	238546	6.3%
3	238474	6.3%
8	238431	6.3%
e	238285	6.2%
5	238244	6.2%
2	238230	6.2%
Other values (6)	1426726	37.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3812576	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
6	239302	6.3%
b	238901	6.3%
1	238720	6.3%
a	238717	6.3%
d	238546	6.3%
3	238474	6.3%
8	238431	6.3%
e	238285	6.2%
5	238244	6.2%
2	238230	6.2%
Other values (6)	1426726	37.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3812576	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
6	239302	6.3%
b	238901	6.3%
1	238720	6.3%
a	238717	6.3%
d	238546	6.3%
3	238474	6.3%
8	238431	6.3%
e	238285	6.2%
5	238244	6.2%
2	238230	6.2%
Other values (6)	1426726	37.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3812576	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
6	239302	6.3%
b	238901	6.3%
1	238720	6.3%
a	238717	6.3%
d	238546	6.3%
3	238474	6.3%
8	238431	6.3%
e	238285	6.2%
5	238244	6.2%
2	238230	6.2%
Other values (6)	1426726	37.4%

customer_zip_code_prefix
Real number (ℝ)

High correlation

Distinct	14994
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35033.451

Minimum	1003
Maximum	99990
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	1003
5-th percentile	3275
Q1	11250
median	24240
Q3	58475
95-th percentile	90570
Maximum	99990
Range	98987
Interquartile range (IQR)	47225

Descriptive statistics

Standard deviation	29823.199
Coefficient of variation (CV)	0.85127779
Kurtosis	-0.78102574
Mean	35033.451
Median Absolute Deviation (MAD)	16230
Skewness	0.7854738
Sum	4.1739905 × 10⁹
Variance	8.894232 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24220	164	0.1%
22790	155	0.1%
22793	154	0.1%
24230	141	0.1%
22775	130	0.1%
35162	125	0.1%
29101	119	0.1%
11740	111	0.1%
13087	108	0.1%
13212	106	0.1%
Other values (14984)	117830	98.9%

Value	Count	Frequency (%)
1003	1	< 0.1%
1004	2	< 0.1%
1005	6	< 0.1%
1006	2	< 0.1%
1007	4	< 0.1%
1008	4	< 0.1%
1009	8	< 0.1%
1011	6	< 0.1%
1012	3	< 0.1%
1013	3	< 0.1%

Value	Count	Frequency (%)
99990	1	< 0.1%
99980	3	< 0.1%
99970	1	< 0.1%
99965	2	< 0.1%
99960	2	< 0.1%
99955	3	< 0.1%
99950	9	< 0.1%
99940	2	< 0.1%
99930	5	< 0.1%
99925	1	< 0.1%

customer_city
Text

Distinct	4119
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

Length

Max length	32
Median length	27
Mean length	10.33532
Min length	3

Characters and Unicode

Total characters	1231381
Distinct characters	31
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1036 ?
Unique (%)	0.9%

Sample

1st row	sao paulo
2nd row	sao paulo
3rd row	sao paulo
4th row	barreiras
5th row	vianopolis

Value	Count	Frequency (%)
sao	25445	12.2%
paulo	18957	9.1%
de	11657	5.6%
rio	9967	4.8%
janeiro	8311	4.0%
do	5095	2.4%
belo	3373	1.6%
horizonte	3327	1.6%
brasilia	2510	1.2%
porto	1998	1.0%
Other values (3285)	118347	56.6%

Most occurring characters

Value	Count	Frequency (%)
a	203082	16.5%
o	151991	12.3%
i	94150	7.6%
r	91236	7.4%
	89844	7.3%
e	79953	6.5%
s	75446	6.1%
n	54566	4.4%
u	54064	4.4%
l	53676	4.4%
Other values (21)	283373	23.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1231381	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	203082	16.5%
o	151991	12.3%
i	94150	7.6%
r	91236	7.4%
	89844	7.3%
e	79953	6.5%
s	75446	6.1%
n	54566	4.4%
u	54064	4.4%
l	53676	4.4%
Other values (21)	283373	23.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1231381	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	203082	16.5%
o	151991	12.3%
i	94150	7.6%
r	91236	7.4%
	89844	7.3%
e	79953	6.5%
s	75446	6.1%
n	54566	4.4%
u	54064	4.4%
l	53676	4.4%
Other values (21)	283373	23.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1231381	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	203082	16.5%
o	151991	12.3%
i	94150	7.6%
r	91236	7.4%
	89844	7.3%
e	79953	6.5%
s	75446	6.1%
n	54566	4.4%
u	54064	4.4%
l	53676	4.4%
Other values (21)	283373	23.0%

customer_state
Categorical

High correlation

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.7 MiB

SP	50265
RJ	15518
MG	13819
RS	6573
PR	6043
Other values (22)	26925

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	238286
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	BA
5th row	GO

Common Values

Value	Count	Frequency (%)
SP	50265	42.2%
RJ	15518	13.0%
MG	13819	11.6%
RS	6573	5.5%
PR	6043	5.1%
SC	4345	3.6%
BA	4091	3.4%
DF	2516	2.1%
GO	2466	2.1%
ES	2360	2.0%
Other values (17)	11147	9.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	50265	42.2%
rj	15518	13.0%
mg	13819	11.6%
rs	6573	5.5%
pr	6043	5.1%
sc	4345	3.6%
ba	4091	3.4%
df	2516	2.1%
go	2466	2.1%
es	2360	2.0%
Other values (17)	11147	9.4%

Most occurring characters

Value	Count	Frequency (%)
S	64808	27.2%
P	60647	25.5%
R	29104	12.2%
M	16842	7.1%
G	16285	6.8%
J	15518	6.5%
A	6892	2.9%
E	6234	2.6%
C	6005	2.5%
B	4735	2.0%
Other values (7)	11216	4.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	238286	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	64808	27.2%
P	60647	25.5%
R	29104	12.2%
M	16842	7.1%
G	16285	6.8%
J	15518	6.5%
A	6892	2.9%
E	6234	2.6%
C	6005	2.5%
B	4735	2.0%
Other values (7)	11216	4.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	238286	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	64808	27.2%
P	60647	25.5%
R	29104	12.2%
M	16842	7.1%
G	16285	6.8%
J	15518	6.5%
A	6892	2.9%
E	6234	2.6%
C	6005	2.5%
B	4735	2.0%
Other values (7)	11216	4.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	238286	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	64808	27.2%
P	60647	25.5%
R	29104	12.2%
M	16842	7.1%
G	16285	6.8%
J	15518	6.5%
A	6892	2.9%
E	6234	2.6%
C	6005	2.5%
B	4735	2.0%
Other values (7)	11216	4.7%

payment_sequential
Real number (ℝ)

Distinct	29
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.0947373

Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	29
Range	28
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.73014099
Coefficient of variation (CV)	0.66695545
Kurtosis	342.28301
Mean	1.0947373
Median Absolute Deviation (MAD)	0
Skewness	15.775506
Sum	130427
Variance	0.53310587
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
1	113999	95.7%
2	3415	2.9%
3	658	0.6%
4	322	0.3%
5	194	0.2%
6	136	0.1%
7	94	0.1%
8	63	0.1%
9	51	< 0.1%
10	42	< 0.1%
Other values (19)	166	0.1%

Value	Count	Frequency (%)
1	113999	95.7%
2	3415	2.9%
3	658	0.6%
4	322	0.3%
5	194	0.2%
6	136	0.1%
7	94	0.1%
8	63	0.1%
9	51	< 0.1%
10	42	< 0.1%

Value	Count	Frequency (%)
29	1	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
26	2	< 0.1%
25	2	< 0.1%
24	2	< 0.1%
23	2	< 0.1%
22	3	< 0.1%
21	6	< 0.1%
20	6	< 0.1%

payment_type
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Memory size	7.6 MiB

credit_card	87776
boleto	23190
voucher	6465
debit_card	1706
not_defined	3

Length

Max length	11
Median length	11
Mean length	9.7954004
Min length	6

Characters and Unicode

Total characters	1167024
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	credit_card
2nd row	voucher
3rd row	voucher
4th row	boleto
5th row	credit_card

Common Values

Value	Count	Frequency (%)
credit_card	87776	73.7%
boleto	23190	19.5%
voucher	6465	5.4%
debit_card	1706	1.4%
not_defined	3	< 0.1%
(Missing)	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
credit_card	87776	73.7%
boleto	23190	19.5%
voucher	6465	5.4%
debit_card	1706	1.4%
not_defined	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
c	183723	15.7%
r	183723	15.7%
d	178970	15.3%
e	119143	10.2%
t	112675	9.7%
i	89485	7.7%
_	89485	7.7%
a	89482	7.7%
o	52848	4.5%
b	24896	2.1%
Other values (6)	42594	3.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1167024	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
c	183723	15.7%
r	183723	15.7%
d	178970	15.3%
e	119143	10.2%
t	112675	9.7%
i	89485	7.7%
_	89485	7.7%
a	89482	7.7%
o	52848	4.5%
b	24896	2.1%
Other values (6)	42594	3.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1167024	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
c	183723	15.7%
r	183723	15.7%
d	178970	15.3%
e	119143	10.2%
t	112675	9.7%
i	89485	7.7%
_	89485	7.7%
a	89482	7.7%
o	52848	4.5%
b	24896	2.1%
Other values (6)	42594	3.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1167024	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
c	183723	15.7%
r	183723	15.7%
d	178970	15.3%
e	119143	10.2%
t	112675	9.7%
i	89485	7.7%
_	89485	7.7%
a	89482	7.7%
o	52848	4.5%
b	24896	2.1%
Other values (6)	42594	3.6%

payment_installments
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.9412456

Minimum	0
Maximum	24
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	10
Maximum	24
Range	24
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.7778477
Coefficient of variation (CV)	0.94444604
Kurtosis	2.5065453
Mean	2.9412456
Median Absolute Deviation (MAD)	1
Skewness	1.6198199
Sum	350420
Variance	7.7164381
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	59446	49.9%
2	13838	11.6%
3	11889	10.0%
4	8072	6.8%
10	6976	5.9%
5	6097	5.1%
8	5120	4.3%
6	4674	3.9%
7	1848	1.6%
9	739	0.6%
Other values (14)	441	0.4%

Value	Count	Frequency (%)
0	3	< 0.1%
1	59446	49.9%
2	13838	11.6%
3	11889	10.0%
4	8072	6.8%
5	6097	5.1%
6	4674	3.9%
7	1848	1.6%
8	5120	4.3%
9	739	0.6%

Value	Count	Frequency (%)
24	34	< 0.1%
23	1	< 0.1%
22	1	< 0.1%
21	6	< 0.1%
20	21	< 0.1%
18	38	< 0.1%
17	8	< 0.1%
16	7	< 0.1%
15	93	0.1%
14	16	< 0.1%

payment_value
Real number (ℝ)

High correlation

Distinct	29077
Distinct (%)	24.4%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	172.73514

Minimum	0
Maximum	13664.08
Zeros	9
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	0
5-th percentile	27.1
Q1	60.85
median	108.16
Q3	189.24
95-th percentile	515.93
Maximum	13664.08
Range	13664.08
Interquartile range (IQR)	128.39

Descriptive statistics

Standard deviation	267.77608
Coefficient of variation (CV)	1.550212
Kurtosis	500.3632
Mean	172.73514
Median Absolute Deviation (MAD)	56.64
Skewness	13.965989
Sum	20579664
Variance	71704.027
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	351	0.3%
100	300	0.3%
20	286	0.2%
77.57	250	0.2%
35	166	0.1%
73.34	160	0.1%
30	139	0.1%
116.94	133	0.1%
56.78	123	0.1%
107.78	120	0.1%
Other values (29067)	117112	98.3%

Value	Count	Frequency (%)
0	9	< 0.1%
0.01	6	< 0.1%
0.03	2	< 0.1%
0.05	2	< 0.1%
0.07	1	< 0.1%
0.08	2	< 0.1%
0.09	1	< 0.1%
0.1	3	< 0.1%
0.11	2	< 0.1%
0.13	2	< 0.1%

Value	Count	Frequency (%)
13664.08	8	< 0.1%
7274.88	4	< 0.1%
6929.31	1	< 0.1%
6922.21	1	< 0.1%
6726.66	1	< 0.1%
6081.54	6	< 0.1%
4950.34	1	< 0.1%
4809.44	2	< 0.1%
4764.34	1	< 0.1%
4681.78	1	< 0.1%

review_id
Text

Distinct	98410
Distinct (%)	83.3%
Missing	997
Missing (%)	0.8%
Memory size	10.1 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3780672
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	85411 ?
Unique (%)	72.3%

Sample

1st row	a54f0611adc9ed256b57ede6b6eb5114
2nd row	a54f0611adc9ed256b57ede6b6eb5114
3rd row	a54f0611adc9ed256b57ede6b6eb5114
4th row	8d5266042046a06655c8db133d120ba5
5th row	e73b67b67587f7644d5bd1a52deb1b01

Value	Count	Frequency (%)
eef5dbca8d37dfce6db7d7b16dd0525e	63	0.1%
7145a6f0d38ec713897856cbdcfcdb7f	38	< 0.1%
f28281373ab8815bafafe371218f02ce	29	< 0.1%
8823bba1e3301fee652eb06de8ef9435	26	< 0.1%
cc074f1c33940c4f0dd904705f98e39e	24	< 0.1%
b0c2f8c122ebef9f77753f7d167cf634	24	< 0.1%
b5292206f96cd5d97359940203a0b510	24	< 0.1%
b79b22bb50f78f1afe361661011fd892	24	< 0.1%
7e568736c98c553aea896a5dca746d5a	22	< 0.1%
e8236fe7b6e1bdd513a500de361e2b87	21	< 0.1%
Other values (98400)	117851	99.8%

Most occurring characters

Value	Count	Frequency (%)
a	237115	6.3%
6	237048	6.3%
5	236734	6.3%
b	236598	6.3%
d	236586	6.3%
8	236562	6.3%
f	236490	6.3%
1	236390	6.3%
0	236298	6.3%
7	236091	6.2%
Other values (6)	1414760	37.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3780672	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	237115	6.3%
6	237048	6.3%
5	236734	6.3%
b	236598	6.3%
d	236586	6.3%
8	236562	6.3%
f	236490	6.3%
1	236390	6.3%
0	236298	6.3%
7	236091	6.2%
Other values (6)	1414760	37.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3780672	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	237115	6.3%
6	237048	6.3%
5	236734	6.3%
b	236598	6.3%
d	236586	6.3%
8	236562	6.3%
f	236490	6.3%
1	236390	6.3%
0	236298	6.3%
7	236091	6.2%
Other values (6)	1414760	37.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3780672	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	237115	6.3%
6	237048	6.3%
5	236734	6.3%
b	236598	6.3%
d	236586	6.3%
8	236562	6.3%
f	236490	6.3%
1	236390	6.3%
0	236298	6.3%
7	236091	6.2%
Other values (6)	1414760	37.4%

review_score
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	997
Missing (%)	0.8%
Memory size	6.8 MiB

5.0	66343
4.0	22319
1.0	15428
3.0	9894
2.0	4162

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	354438
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4.0
2nd row	4.0
3rd row	4.0
4th row	4.0
5th row	5.0

Common Values

Value	Count	Frequency (%)
5.0	66343	55.7%
4.0	22319	18.7%
1.0	15428	12.9%
3.0	9894	8.3%
2.0	4162	3.5%
(Missing)	997	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5.0	66343	56.2%
4.0	22319	18.9%
1.0	15428	13.1%
3.0	9894	8.4%
2.0	4162	3.5%

Most occurring characters

Value	Count	Frequency (%)
.	118146	33.3%
0	118146	33.3%
5	66343	18.7%
4	22319	6.3%
1	15428	4.4%
3	9894	2.8%
2	4162	1.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	354438	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	118146	33.3%
0	118146	33.3%
5	66343	18.7%
4	22319	6.3%
1	15428	4.4%
3	9894	2.8%
2	4162	1.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	354438	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	118146	33.3%
0	118146	33.3%
5	66343	18.7%
4	22319	6.3%
1	15428	4.4%
3	9894	2.8%
2	4162	1.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	354438	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	118146	33.3%
0	118146	33.3%
5	66343	18.7%
4	22319	6.3%
1	15428	4.4%
3	9894	2.8%
2	4162	1.2%

review_comment_title
Text

Missing

Distinct	4527
Distinct (%)	32.4%
Missing	105154
Missing (%)	88.3%
Memory size	4.3 MiB

Length

Max length	26
Median length	20
Mean length	12.213525
Min length	1

Characters and Unicode

Total characters	170855
Distinct characters	125
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3095 ?
Unique (%)	22.1%

Sample

1st row	Muito boa a loja
2nd row	Nota dez
3rd row	Ótimo
4th row	NÃO RECOMENDO!!!!
5th row	NÃO RECOMENDO!!!!

Value	Count	Frequency (%)
recomendo	2478	9.3%
produto	1570	5.9%
bom	1521	5.7%
muito	1040	3.9%
super	1039	3.9%
não	937	3.5%
ótimo	809	3.0%
excelente	769	2.9%
entrega	716	2.7%
recebi	445	1.7%
Other values (2100)	15445	57.7%

Most occurring characters

Value	Count	Frequency (%)
o	21273	12.5%
e	18299	10.7%
	15200	8.9%
r	9902	5.8%
t	9433	5.5%
a	9158	5.4%
m	8444	4.9%
d	8214	4.8%
i	8084	4.7%
n	7660	4.5%
Other values (115)	55188	32.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	170855	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	21273	12.5%
e	18299	10.7%
	15200	8.9%
r	9902	5.8%
t	9433	5.5%
a	9158	5.4%
m	8444	4.9%
d	8214	4.8%
i	8084	4.7%
n	7660	4.5%
Other values (115)	55188	32.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	170855	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	21273	12.5%
e	18299	10.7%
	15200	8.9%
r	9902	5.8%
t	9433	5.5%
a	9158	5.4%
m	8444	4.9%
d	8214	4.8%
i	8084	4.7%
n	7660	4.5%
Other values (115)	55188	32.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	170855	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	21273	12.5%
e	18299	10.7%
	15200	8.9%
r	9902	5.8%
t	9433	5.5%
a	9158	5.4%
m	8444	4.9%
d	8214	4.8%
i	8084	4.7%
n	7660	4.5%
Other values (115)	55188	32.3%

review_comment_message
Text

Missing

Distinct	36159
Distinct (%)	72.0%
Missing	68898
Missing (%)	57.8%
Memory size	11.6 MiB

Length

Max length	208
Median length	159
Mean length	70.656662
Min length	1

Characters and Unicode

Total characters	3550144
Distinct characters	209
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	29556 ?
Unique (%)	58.8%

Sample

1st row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
2nd row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
3rd row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
4th row	Muito bom o produto.
5th row	O produto foi exatamente o que eu esperava e estava descrito no site e chegou bem antes da data prevista.

Value	Count	Frequency (%)
o	23016	3.8%
produto	21207	3.5%
e	20046	3.3%
a	15246	2.5%
de	14566	2.4%
não	13436	2.2%
do	13109	2.2%
que	10560	1.7%
prazo	9427	1.6%
muito	9086	1.5%
Other values (19737)	456676	75.3%

Most occurring characters

Value	Count	Frequency (%)
	562672	15.8%
o	350271	9.9%
e	340009	9.6%
a	282074	7.9%
r	200163	5.6%
i	163758	4.6%
t	161344	4.5%
d	150134	4.2%
n	138033	3.9%
s	134085	3.8%
Other values (199)	1067601	30.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3550144	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	562672	15.8%
o	350271	9.9%
e	340009	9.6%
a	282074	7.9%
r	200163	5.6%
i	163758	4.6%
t	161344	4.5%
d	150134	4.2%
n	138033	3.9%
s	134085	3.8%
Other values (199)	1067601	30.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3550144	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	562672	15.8%
o	350271	9.9%
e	340009	9.6%
a	282074	7.9%
r	200163	5.6%
i	163758	4.6%
t	161344	4.5%
d	150134	4.2%
n	138033	3.9%
s	134085	3.8%
Other values (199)	1067601	30.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3550144	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	562672	15.8%
o	350271	9.9%
e	340009	9.6%
a	282074	7.9%
r	200163	5.6%
i	163758	4.6%
t	161344	4.5%
d	150134	4.2%
n	138033	3.9%
s	134085	3.8%
Other values (199)	1067601	30.1%

review_creation_date
Date

Distinct	636
Distinct (%)	0.5%
Missing	997
Missing (%)	0.8%
Memory size	930.9 KiB

Minimum	2016-10-02 00:00:00
Maximum	2018-08-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

review_answer_timestamp
Date

Distinct	98248
Distinct (%)	83.2%
Missing	997
Missing (%)	0.8%
Memory size	930.9 KiB

Minimum	2016-10-07 18:32:28
Maximum	2018-10-29 12:27:35
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_item_id
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	833
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	1.196543

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	21
Range	20
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6994889
Coefficient of variation (CV)	0.58459154
Kurtosis	103.35482
Mean	1.196543
Median Absolute Deviation (MAD)	0
Skewness	7.5517266
Sum	141563
Variance	0.48928472
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	103645	87.0%
2	10317	8.7%
3	2396	2.0%
4	995	0.8%
5	472	0.4%
6	265	0.2%
7	61	0.1%
8	37	< 0.1%
9	29	< 0.1%
10	26	< 0.1%
Other values (11)	67	0.1%
(Missing)	833	0.7%

Value	Count	Frequency (%)
1	103645	87.0%
2	10317	8.7%
3	2396	2.0%
4	995	0.8%
5	472	0.4%
6	265	0.2%
7	61	0.1%
8	37	< 0.1%
9	29	< 0.1%
10	26	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	3	< 0.1%
19	3	< 0.1%
18	3	< 0.1%
17	3	< 0.1%
16	3	< 0.1%
15	5	< 0.1%
14	7	< 0.1%
13	8	< 0.1%
12	13	< 0.1%

product_id
Text

Distinct	32951
Distinct (%)	27.9%
Missing	833
Missing (%)	0.7%
Memory size	10.1 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3785920
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17345 ?
Unique (%)	14.7%

Sample

1st row	87285b34884572647811a353c7ac498a
2nd row	87285b34884572647811a353c7ac498a
3rd row	87285b34884572647811a353c7ac498a
4th row	595fac2a385ac33a80bd5114aec74eb8
5th row	aa4383b373c6aca5d8797843e5594415

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	536	0.5%
99a4788cb24856965c36a24e339b6058	528	0.4%
422879e10f46682990de24d770e7f83d	508	0.4%
389d119b48cf3043d311335e499d9c6b	406	0.3%
368c6c730842d78016ad823897a372db	398	0.3%
53759a2ecddad2bb87a079a1f1519f73	391	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	357	0.3%
53b36df67ebb7c41585e8d54d6772e08	327	0.3%
154e7e31ebfa092203795c972e5804a6	295	0.2%
3dd2a17168ec895c781a9191c1e95ad7	278	0.2%
Other values (32941)	114286	96.6%

Most occurring characters

Value	Count	Frequency (%)
3	243128	6.4%
9	241092	6.4%
e	238897	6.3%
8	238246	6.3%
7	238157	6.3%
4	237487	6.3%
a	237289	6.3%
c	236394	6.2%
0	236277	6.2%
2	236110	6.2%
Other values (6)	1402843	37.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3785920	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	243128	6.4%
9	241092	6.4%
e	238897	6.3%
8	238246	6.3%
7	238157	6.3%
4	237487	6.3%
a	237289	6.3%
c	236394	6.2%
0	236277	6.2%
2	236110	6.2%
Other values (6)	1402843	37.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3785920	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	243128	6.4%
9	241092	6.4%
e	238897	6.3%
8	238246	6.3%
7	238157	6.3%
4	237487	6.3%
a	237289	6.3%
c	236394	6.2%
0	236277	6.2%
2	236110	6.2%
Other values (6)	1402843	37.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3785920	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	243128	6.4%
9	241092	6.4%
e	238897	6.3%
8	238246	6.3%
7	238157	6.3%
4	237487	6.3%
a	237289	6.3%
c	236394	6.2%
0	236277	6.2%
2	236110	6.2%
Other values (6)	1402843	37.1%

seller_id
Text

Distinct	3095
Distinct (%)	2.6%
Missing	833
Missing (%)	0.7%
Memory size	10.1 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3785920
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	487 ?
Unique (%)	0.4%

Sample

1st row	3504c0cb71d7fa48d967e0e4c94d59d9
2nd row	3504c0cb71d7fa48d967e0e4c94d59d9
3rd row	3504c0cb71d7fa48d967e0e4c94d59d9
4th row	289cdb325fb7e7f891c38608bf9e0962
5th row	4869f7a5dfa277a7dca6462dcf3b52b2

Value	Count	Frequency (%)
4a3ca9315b744ce9f8e9374361493884	2155	1.8%
6560211a19b47992c3666cc44a7e94c0	2130	1.8%
1f50f920176fa81dab994f9023523100	2017	1.7%
cc419e0650a3c5ba77189a1882b7556a	1893	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1662	1.4%
955fee9216a65b617aa5c0531780ce60	1530	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1477	1.2%
7c67e1448b00f6e969d365cea6b010ab	1463	1.2%
7a67c85e85bb2ce8582c35f2203ad736	1245	1.1%
ea8482cd71df3c1969d7b9473ff13abc	1240	1.0%
Other values (3085)	101498	85.8%

Most occurring characters

Value	Count	Frequency (%)
1	256833	6.8%
c	250006	6.6%
4	248481	6.6%
6	243514	6.4%
0	242843	6.4%
a	241350	6.4%
b	240801	6.4%
3	240746	6.4%
9	235027	6.2%
2	233698	6.2%
Other values (6)	1352621	35.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3785920	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	256833	6.8%
c	250006	6.6%
4	248481	6.6%
6	243514	6.4%
0	242843	6.4%
a	241350	6.4%
b	240801	6.4%
3	240746	6.4%
9	235027	6.2%
2	233698	6.2%
Other values (6)	1352621	35.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3785920	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	256833	6.8%
c	250006	6.6%
4	248481	6.6%
6	243514	6.4%
0	242843	6.4%
a	241350	6.4%
b	240801	6.4%
3	240746	6.4%
9	235027	6.2%
2	233698	6.2%
Other values (6)	1352621	35.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3785920	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	256833	6.8%
c	250006	6.6%
4	248481	6.6%
6	243514	6.4%
0	242843	6.4%
a	241350	6.4%
b	240801	6.4%
3	240746	6.4%
9	235027	6.2%
2	233698	6.2%
Other values (6)	1352621	35.7%

shipping_limit_date
Date

Distinct	93318
Distinct (%)	78.9%
Missing	833
Missing (%)	0.7%
Memory size	930.9 KiB

Minimum	2016-09-19 00:15:34
Maximum	2020-04-09 22:35:08
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

price
Real number (ℝ)

High correlation

Distinct	5968
Distinct (%)	5.0%
Missing	833
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	120.6466

Minimum	0.85
Maximum	6735
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	0.85
5-th percentile	17
Q1	39.9
median	74.9
Q3	134.9
95-th percentile	349.9
Maximum	6735
Range	6734.15
Interquartile range (IQR)	95

Descriptive statistics

Standard deviation	184.10969
Coefficient of variation (CV)	1.5260247
Kurtosis	119.15494
Mean	120.6466
Median Absolute Deviation (MAD)	42
Skewness	7.8925735
Sum	14273700
Variance	33896.378
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.9	2619	2.2%
69.9	2113	1.8%
49.9	2051	1.7%
89.9	1644	1.4%
99.9	1526	1.3%
39.9	1403	1.2%
29.9	1387	1.2%
19.9	1284	1.1%
79.9	1282	1.1%
29.99	1228	1.0%
Other values (5958)	101773	85.4%

Value	Count	Frequency (%)
0.85	3	< 0.1%
1.2	20	< 0.1%
2.2	2	< 0.1%
2.29	1	< 0.1%
2.9	1	< 0.1%
2.99	1	< 0.1%
3	2	< 0.1%
3.06	3	< 0.1%
3.49	3	< 0.1%
3.5	7	< 0.1%

Value	Count	Frequency (%)
6735	1	< 0.1%
6729	1	< 0.1%
6499	1	< 0.1%
4799	1	< 0.1%
4690	1	< 0.1%
4590	1	< 0.1%
4399.87	1	< 0.1%
4099.99	1	< 0.1%
4059	1	< 0.1%
3999.9	1	< 0.1%

freight_value
Real number (ℝ)

Distinct	6999
Distinct (%)	5.9%
Missing	833
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	20.032387

Minimum	0
Maximum	409.68
Zeros	390
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	0
5-th percentile	7.78
Q1	13.08
median	16.28
Q3	21.18
95-th percentile	45.3
Maximum	409.68
Range	409.68
Interquartile range (IQR)	8.1

Descriptive statistics

Standard deviation	15.83685
Coefficient of variation (CV)	0.79056234
Kurtosis	57.635327
Mean	20.032387
Median Absolute Deviation (MAD)	3.63
Skewness	5.5433839
Sum	2370031.6
Variance	250.80583
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.1	3861	3.2%
7.78	2355	2.0%
11.85	1999	1.7%
14.1	1992	1.7%
18.23	1632	1.4%
7.39	1573	1.3%
16.11	1211	1.0%
15.23	1064	0.9%
8.72	970	0.8%
16.79	930	0.8%
Other values (6989)	100723	84.5%

Value	Count	Frequency (%)
0	390	0.3%
0.01	4	< 0.1%
0.02	3	< 0.1%
0.03	14	< 0.1%
0.04	4	< 0.1%
0.05	9	< 0.1%
0.06	13	< 0.1%
0.07	1	< 0.1%
0.08	12	< 0.1%
0.09	6	< 0.1%

Value	Count	Frequency (%)
409.68	1	< 0.1%
375.28	2	< 0.1%
339.59	1	< 0.1%
338.3	1	< 0.1%
322.1	1	< 0.1%
321.88	1	< 0.1%
321.46	1	< 0.1%
317.47	1	< 0.1%
314.4	1	< 0.1%
314.02	1	< 0.1%

product_category_name
Text

Missing

Distinct	73
Distinct (%)	0.1%
Missing	2542
Missing (%)	2.1%
Memory size	8.1 MiB

Length

Max length	46
Median length	32
Mean length	14.876202
Min length	3

Characters and Unicode

Total characters	1734580
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	utilidades_domesticas
2nd row	utilidades_domesticas
3rd row	utilidades_domesticas
4th row	perfumaria
5th row	automotivo

Value	Count	Frequency (%)
cama_mesa_banho	11988	10.3%
beleza_saude	10032	8.6%
esporte_lazer	9004	7.7%
moveis_decoracao	8832	7.6%
informatica_acessorios	8150	7.0%
utilidades_domesticas	7380	6.3%
relogios_presentes	6213	5.3%
telefonia	4726	4.1%
ferramentas_jardim	4590	3.9%
automotivo	4400	3.8%
Other values (63)	41286	35.4%

Most occurring characters

Value	Count	Frequency (%)
e	210541	12.1%
a	208834	12.0%
s	172854	10.0%
o	171612	9.9%
i	115171	6.6%
r	111455	6.4%
_	110493	6.4%
t	83288	4.8%
c	82435	4.8%
m	78683	4.5%
Other values (18)	389214	22.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1734580	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	210541	12.1%
a	208834	12.0%
s	172854	10.0%
o	171612	9.9%
i	115171	6.6%
r	111455	6.4%
_	110493	6.4%
t	83288	4.8%
c	82435	4.8%
m	78683	4.5%
Other values (18)	389214	22.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1734580	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	210541	12.1%
a	208834	12.0%
s	172854	10.0%
o	171612	9.9%
i	115171	6.6%
r	111455	6.4%
_	110493	6.4%
t	83288	4.8%
c	82435	4.8%
m	78683	4.5%
Other values (18)	389214	22.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1734580	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	210541	12.1%
a	208834	12.0%
s	172854	10.0%
o	171612	9.9%
i	115171	6.6%
r	111455	6.4%
_	110493	6.4%
t	83288	4.8%
c	82435	4.8%
m	78683	4.5%
Other values (18)	389214	22.4%

product_name_lenght
Real number (ℝ)

Missing

Distinct	66
Distinct (%)	0.1%
Missing	2542
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	48.767498

Minimum	5
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	5
5-th percentile	29
Q1	42
median	52
Q3	57
95-th percentile	60
Maximum	76
Range	71
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.03354
Coefficient of variation (CV)	0.20574236
Kurtosis	0.14950788
Mean	48.767498
Median Absolute Deviation (MAD)	6
Skewness	-0.90489402
Sum	5686339
Variance	100.67193
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59	8679	7.3%
60	8070	6.8%
56	6847	5.7%
58	6819	5.7%
57	6302	5.3%
55	5833	4.9%
54	5529	4.6%
53	4357	3.7%
52	4328	3.6%
49	3690	3.1%
Other values (56)	56147	47.1%

Value	Count	Frequency (%)
5	9	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	4	< 0.1%
9	15	< 0.1%
10	9	< 0.1%
11	11	< 0.1%
12	38	< 0.1%
13	26	< 0.1%
14	47	< 0.1%

Value	Count	Frequency (%)
76	1	< 0.1%
72	9	< 0.1%
69	1	< 0.1%
68	1	< 0.1%
67	3	< 0.1%
66	1	< 0.1%
64	174	0.1%
63	1350	1.1%
62	167	0.1%
61	241	0.2%

product_description_lenght
Real number (ℝ)

Missing

Distinct	2960
Distinct (%)	2.5%
Missing	2542
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	785.96782

Minimum	4
Maximum	3992
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	4
5-th percentile	160
Q1	346
median	600
Q3	983
95-th percentile	2123
Maximum	3992
Range	3988
Interquartile range (IQR)	637

Descriptive statistics

Standard deviation	652.58412
Coefficient of variation (CV)	0.83029369
Kurtosis	4.9299321
Mean	785.96782
Median Absolute Deviation (MAD)	296
Skewness	2.0121562
Sum	91644634
Variance	425866.03
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
341	711	0.6%
1893	667	0.6%
348	648	0.5%
492	594	0.5%
903	594	0.5%
245	587	0.5%
366	537	0.5%
236	516	0.4%
340	487	0.4%
919	442	0.4%
Other values (2950)	110818	93.0%
(Missing)	2542	2.1%

Value	Count	Frequency (%)
4	6	< 0.1%
8	2	< 0.1%
15	1	< 0.1%
20	7	< 0.1%
23	1	< 0.1%
26	2	< 0.1%
27	4	< 0.1%
28	2	< 0.1%
30	8	< 0.1%
31	2	< 0.1%

Value	Count	Frequency (%)
3992	2	< 0.1%
3988	1	< 0.1%
3985	3	< 0.1%
3976	6	< 0.1%
3963	1	< 0.1%
3956	3	< 0.1%
3954	2	< 0.1%
3950	2	< 0.1%
3949	1	< 0.1%
3948	1	< 0.1%

product_photos_qty
Real number (ℝ)

Missing

Distinct	19
Distinct (%)	< 0.1%
Missing	2542
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.2051612

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	6
Maximum	20
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.7174519
Coefficient of variation (CV)	0.7788328
Kurtosis	4.8200793
Mean	2.2051612
Median Absolute Deviation (MAD)	0
Skewness	1.9087497
Sum	257124
Variance	2.9496409
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	58957	49.5%
2	23054	19.3%
3	12978	10.9%
4	8863	7.4%
5	5599	4.7%
6	3945	3.3%
7	1560	1.3%
8	774	0.6%
10	354	0.3%
9	318	0.3%
Other values (9)	199	0.2%
(Missing)	2542	2.1%

Value	Count	Frequency (%)
1	58957	49.5%
2	23054	19.3%
3	12978	10.9%
4	8863	7.4%
5	5599	4.7%
6	3945	3.3%
7	1560	1.3%
8	774	0.6%
9	318	0.3%
10	354	0.3%

Value	Count	Frequency (%)
20	1	< 0.1%
19	2	< 0.1%
18	4	< 0.1%
17	11	< 0.1%
15	12	< 0.1%
14	6	< 0.1%
13	30	< 0.1%
12	60	0.1%
11	73	0.1%
10	354	0.3%

product_weight_g
Real number (ℝ)

High correlation

Distinct	2204
Distinct (%)	1.9%
Missing	853
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	2112.2507

Minimum	0
Maximum	40425
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	0
5-th percentile	125
Q1	300
median	700
Q3	1800
95-th percentile	9850
Maximum	40425
Range	40425
Interquartile range (IQR)	1500

Descriptive statistics

Standard deviation	3786.6951
Coefficient of variation (CV)	1.7927299
Kurtosis	16.01826
Mean	2112.2507
Median Absolute Deviation (MAD)	500
Skewness	3.5830918
Sum	2.4985814 × 10⁸
Variance	14339060
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	7093	6.0%
150	5410	4.5%
250	4741	4.0%
300	4429	3.7%
400	3787	3.2%
100	3666	3.1%
350	3291	2.8%
500	2856	2.4%
600	2838	2.4%
700	2148	1.8%
Other values (2194)	78031	65.5%

Value	Count	Frequency (%)
0	8	< 0.1%
2	5	< 0.1%
25	3	< 0.1%
50	991	0.8%
53	2	< 0.1%
54	2	< 0.1%
55	2	< 0.1%
58	1	< 0.1%
60	9	< 0.1%
61	5	< 0.1%

Value	Count	Frequency (%)
40425	3	< 0.1%
30000	303	0.3%
29800	1	< 0.1%
29750	1	< 0.1%
29700	4	< 0.1%
29600	5	< 0.1%
29500	2	< 0.1%
29250	1	< 0.1%
29150	1	< 0.1%
29100	1	< 0.1%

product_length_cm
Real number (ℝ)

High correlation

Distinct	99
Distinct (%)	0.1%
Missing	853
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	30.265145

Minimum	7
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	7
5-th percentile	16
Q1	18
median	25
Q3	38
95-th percentile	62
Maximum	105
Range	98
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	16.189367
Coefficient of variation (CV)	0.53491788
Kurtosis	3.6785662
Mean	30.265145
Median Absolute Deviation (MAD)	8
Skewness	1.7456849
Sum	3580064
Variance	262.09561
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	18363	15.4%
20	10999	9.2%
30	7951	6.7%
17	6202	5.2%
18	5909	5.0%
19	4898	4.1%
25	4871	4.1%
40	4360	3.7%
22	4000	3.4%
50	3163	2.7%
Other values (89)	47574	39.9%

Value	Count	Frequency (%)
7	32	< 0.1%
8	2	< 0.1%
9	4	< 0.1%
10	8	< 0.1%
11	96	0.1%
12	41	< 0.1%
13	60	0.1%
14	138	0.1%
15	220	0.2%
16	18363	15.4%

Value	Count	Frequency (%)
105	335	0.3%
104	35	< 0.1%
103	46	< 0.1%
102	60	0.1%
101	108	0.1%
100	429	0.4%
99	36	< 0.1%
98	50	< 0.1%
97	11	< 0.1%
96	8	< 0.1%

product_height_cm
Real number (ℝ)

High correlation

Distinct	102
Distinct (%)	0.1%
Missing	853
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	16.619706

Minimum	2
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	13
Q3	20
95-th percentile	45
Maximum	105
Range	103
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	13.453584
Coefficient of variation (CV)	0.80949592
Kurtosis	7.2778781
Mean	16.619706
Median Absolute Deviation (MAD)	6
Skewness	2.2389625
Sum	1965945
Variance	180.99892
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	10374	8.7%
20	6915	5.8%
15	6896	5.8%
12	6520	5.5%
11	6432	5.4%
2	5254	4.4%
4	4910	4.1%
8	4873	4.1%
5	4776	4.0%
16	4765	4.0%
Other values (92)	56575	47.5%

Value	Count	Frequency (%)
2	5254	4.4%
3	2821	2.4%
4	4910	4.1%
5	4776	4.0%
6	3576	3.0%
7	4387	3.7%
8	4873	4.1%
9	3408	2.9%
10	10374	8.7%
11	6432	5.4%

Value	Count	Frequency (%)
105	139	0.1%
104	14	< 0.1%
103	49	< 0.1%
102	10	< 0.1%
100	43	< 0.1%
99	5	< 0.1%
98	3	< 0.1%
97	2	< 0.1%
96	8	< 0.1%
95	22	< 0.1%

product_width_cm
Real number (ℝ)

High correlation

Distinct	95
Distinct (%)	0.1%
Missing	853
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	23.074799

Minimum	6
Maximum	118
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	6
5-th percentile	11
Q1	15
median	20
Q3	30
95-th percentile	45
Maximum	118
Range	112
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.749139
Coefficient of variation (CV)	0.50917622
Kurtosis	4.5530162
Mean	23.074799
Median Absolute Deviation (MAD)	6
Skewness	1.707171
Sum	2729518
Variance	138.04227
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	12701	10.7%
11	11144	9.4%
15	9376	7.9%
16	8810	7.4%
30	8045	6.8%
12	5711	4.8%
13	5491	4.6%
14	4846	4.1%
18	4192	3.5%
40	4157	3.5%
Other values (85)	43817	36.8%

Value	Count	Frequency (%)
6	2	< 0.1%
7	5	< 0.1%
8	29	< 0.1%
9	51	< 0.1%
10	83	0.1%
11	11144	9.4%
12	5711	4.8%
13	5491	4.6%
14	4846	4.1%
15	9376	7.9%

Value	Count	Frequency (%)
118	8	< 0.1%
105	14	< 0.1%
104	1	< 0.1%
103	1	< 0.1%
102	2	< 0.1%
101	2	< 0.1%
100	43	< 0.1%
98	1	< 0.1%
97	1	< 0.1%
95	2	< 0.1%

zip_code_prefix
Real number (ℝ)

High correlation

Distinct	2246
Distinct (%)	1.9%
Missing	833
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	24442.41

Minimum	1001
Maximum	99730
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	930.9 KiB

Quantile statistics

Minimum	1001
5-th percentile	2972
Q1	6429
median	13660
Q3	27972
95-th percentile	88308
Maximum	99730
Range	98729
Interquartile range (IQR)	21543

Descriptive statistics

Standard deviation	27573.005
Coefficient of variation (CV)	1.1280804
Kurtosis	0.93697995
Mean	24442.41
Median Absolute Deviation (MAD)	8123
Skewness	1.5561361
Sum	2.8917816 × 10⁹
Variance	7.6027058 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14940	8373	7.0%
5849	2145	1.8%
15025	2098	1.8%
9015	1899	1.6%
13405	1678	1.4%
8577	1556	1.3%
4782	1549	1.3%
3204	1477	1.2%
4160	1268	1.1%
13232	1255	1.1%
Other values (2236)	95012	79.7%

Value	Count	Frequency (%)
1001	22	< 0.1%
1021	41	< 0.1%
1022	5	< 0.1%
1023	5	< 0.1%
1026	323	0.3%
1031	129	0.1%
1035	18	< 0.1%
1039	1	< 0.1%
1040	25	< 0.1%
1041	2	< 0.1%

Value	Count	Frequency (%)
99730	12	< 0.1%
99700	2	< 0.1%
99670	1	< 0.1%
99500	61	0.1%
99300	2	< 0.1%
98975	22	< 0.1%
98920	2	< 0.1%
98910	14	< 0.1%
98803	66	0.1%
98780	4	< 0.1%

seller_city
Text

Distinct	611
Distinct (%)	0.5%
Missing	833
Missing (%)	0.7%
Memory size	7.6 MiB

Length

Max length	40
Median length	31
Mean length	10.102451
Min length	2

Characters and Unicode

Total characters	1195221
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	64 ?
Unique (%)	0.1%

Sample

1st row	maua
2nd row	maua
3rd row	maua
4th row	belo horizonte
5th row	guariba

Value	Count	Frequency (%)
sao	36362	17.9%
paulo	29574	14.5%
ibitinga	8373	4.1%
rio	5930	2.9%
do	5524	2.7%
preto	5518	2.7%
de	4192	2.1%
jose	4085	2.0%
santo	3270	1.6%
andre	3164	1.6%
Other values (640)	97267	47.9%

Most occurring characters

Value	Count	Frequency (%)
a	198772	16.6%
o	146215	12.2%
i	102111	8.5%
	85009	7.1%
r	78220	6.5%
s	76216	6.4%
e	64170	5.4%
u	62907	5.3%
p	58419	4.9%
l	56917	4.8%
Other values (31)	266265	22.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1195221	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	198772	16.6%
o	146215	12.2%
i	102111	8.5%
	85009	7.1%
r	78220	6.5%
s	76216	6.4%
e	64170	5.4%
u	62907	5.3%
p	58419	4.9%
l	56917	4.8%
Other values (31)	266265	22.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1195221	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	198772	16.6%
o	146215	12.2%
i	102111	8.5%
	85009	7.1%
r	78220	6.5%
s	76216	6.4%
e	64170	5.4%
u	62907	5.3%
p	58419	4.9%
l	56917	4.8%
Other values (31)	266265	22.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1195221	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	198772	16.6%
o	146215	12.2%
i	102111	8.5%
	85009	7.1%
r	78220	6.5%
s	76216	6.4%
e	64170	5.4%
u	62907	5.3%
p	58419	4.9%
l	56917	4.8%
Other values (31)	266265	22.3%

seller_state
Categorical

High correlation Imbalance

Distinct	23
Distinct (%)	< 0.1%
Missing	833
Missing (%)	0.7%
Memory size	6.7 MiB

SP	84377
MG	9314
PR	9096
RJ	5036
SC	4271
Other values (18)	6216

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	236620
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	SP
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	84377	70.8%
MG	9314	7.8%
PR	9096	7.6%
RJ	5036	4.2%
SC	4271	3.6%
RS	2294	1.9%
DF	949	0.8%
BA	700	0.6%
GO	550	0.5%
PE	465	0.4%
Other values (13)	1258	1.1%
(Missing)	833	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	84377	71.3%
mg	9314	7.9%
pr	9096	7.7%
rj	5036	4.3%
sc	4271	3.6%
rs	2294	1.9%
df	949	0.8%
ba	700	0.6%
go	550	0.5%
pe	465	0.4%
Other values (13)	1258	1.1%

Most occurring characters

Value	Count	Frequency (%)
P	94002	39.7%
S	91402	38.6%
R	16496	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	236620	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
P	94002	39.7%
S	91402	38.6%
R	16496	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	236620	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
P	94002	39.7%
S	91402	38.6%
R	16496	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	236620	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
P	94002	39.7%
S	91402	38.6%
R	16496	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

geolocation_lat
Real number (ℝ)

High correlation

Distinct	2239
Distinct (%)	1.9%
Missing	1098
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	-22.797849

Minimum	-36.605374
Maximum	-2.5460792
Zeros	0
Zeros (%)	0.0%
Negative	118045
Negative (%)	99.1%
Memory size	930.9 KiB

Quantile statistics

Minimum	-36.605374
5-th percentile	-26.322991
Q1	-23.609026
median	-23.422076
Q3	-21.766477
95-th percentile	-19.849883
Maximum	-2.5460792
Range	34.059295
Interquartile range (IQR)	1.8425493

Descriptive statistics

Standard deviation	2.6904204
Coefficient of variation (CV)	-0.11801202
Kurtosis	18.250517
Mean	-22.797849
Median Absolute Deviation (MAD)	0.53597732
Skewness	2.7582692
Sum	-2691172.1
Variance	7.2383618
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-21.76647685	8373	7.0%
-23.65111484	2145	1.8%
-20.80243626	2098	1.8%
-23.66570346	1899	1.6%
-22.71683929	1678	1.4%
-23.48262344	1556	1.3%
-23.693986	1549	1.3%
-23.59798552	1477	1.2%
-23.62358155	1268	1.1%
-23.20706431	1255	1.1%
Other values (2229)	94747	79.5%

Value	Count	Frequency (%)
-36.60537441	4	< 0.1%
-32.07951338	18	< 0.1%
-31.77241287	2	< 0.1%
-31.74423096	11	< 0.1%
-31.32151917	1	< 0.1%
-30.1594693	77	0.1%
-30.1100209	19	< 0.1%
-30.10330372	6	< 0.1%
-30.09981943	5	< 0.1%
-30.08061351	5	< 0.1%

Value	Count	Frequency (%)
-2.546079234	410	0.3%
-3.135622683	3	< 0.1%
-3.719036598	14	< 0.1%
-3.723306129	3	< 0.1%
-3.723672447	1	< 0.1%
-3.743987899	4	< 0.1%
-3.759209507	1	< 0.1%
-3.769923	35	< 0.1%
-3.780360995	12	< 0.1%
-3.783814827	16	< 0.1%

geolocation_lng
Real number (ℝ)

High correlation

Distinct	2239
Distinct (%)	1.9%
Missing	1098
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	-47.238603

Minimum	-67.809656
Maximum	-34.847856
Zeros	0
Zeros (%)	0.0%
Negative	118045
Negative (%)	99.1%
Memory size	930.9 KiB

Quantile statistics

Minimum	-67.809656
5-th percentile	-51.368949
Q1	-48.831547
median	-46.755211
Q3	-46.518082
95-th percentile	-43.297621
Maximum	-34.847856
Range	32.9618
Interquartile range (IQR)	2.3134654

Descriptive statistics

Standard deviation	2.3411036
Coefficient of variation (CV)	-0.049559122
Kurtosis	4.8442036
Mean	-47.238603
Median Absolute Deviation (MAD)	0.72882376
Skewness	0.55253099
Sum	-5576280.8
Variance	5.4807663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-48.83154738	8373	7.0%
-46.75521082	2145	1.8%
-49.39562407	2098	1.8%
-46.51808197	1899	1.6%
-47.65736585	1678	1.4%
-46.37448953	1556	1.3%
-46.70188324	1549	1.3%
-46.55547279	1477	1.2%
-46.61056007	1268	1.1%
-46.76073521	1255	1.1%
Other values (2229)	94747	79.5%

Value	Count	Frequency (%)
-67.8096558	1	< 0.1%
-64.28394646	4	< 0.1%
-63.88797299	6	< 0.1%
-61.95720116	8	< 0.1%
-60.02346888	3	< 0.1%
-57.08632042	1	< 0.1%
-56.10296014	52	< 0.1%
-56.06797233	37	< 0.1%
-55.49644289	56	< 0.1%
-54.96989318	2	< 0.1%

Value	Count	Frequency (%)
-34.84785618	1	< 0.1%
-34.8557625	9	< 0.1%
-34.89678629	3	< 0.1%
-34.89853108	16	< 0.1%
-34.90155285	1	< 0.1%
-34.91839939	6	< 0.1%
-34.93222646	386	0.3%
-35.12509238	16	< 0.1%
-35.20164321	23	< 0.1%
-35.20826027	16	< 0.1%

geolocation_city
Text

Distinct	595
Distinct (%)	0.5%
Missing	1098
Missing (%)	0.9%
Memory size	7.9 MiB

Length

Max length	25
Median length	23
Mean length	10.075361
Min length	3

Characters and Unicode

Total characters	1189346
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	55 ?
Unique (%)	< 0.1%

Sample

1st row	maua
2nd row	maua
3rd row	maua
4th row	belo horizonte
5th row	guariba

Value	Count	Frequency (%)
sao	30528	15.1%
paulo	29515	14.6%
ibitinga	8373	4.1%
são	5968	3.0%
rio	5905	2.9%
do	5604	2.8%
preto	5400	2.7%
de	3879	1.9%
jose	3675	1.8%
santo	3285	1.6%
Other values (639)	99814	49.4%

Most occurring characters

Value	Count	Frequency (%)
a	191810	16.1%
o	144781	12.2%
i	100598	8.5%
	83901	7.1%
r	77632	6.5%
s	75861	6.4%
u	63166	5.3%
e	62314	5.2%
p	57905	4.9%
l	56870	4.8%
Other values (25)	274508	23.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1189346	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	191810	16.1%
o	144781	12.2%
i	100598	8.5%
	83901	7.1%
r	77632	6.5%
s	75861	6.4%
u	63166	5.3%
e	62314	5.2%
p	57905	4.9%
l	56870	4.8%
Other values (25)	274508	23.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1189346	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	191810	16.1%
o	144781	12.2%
i	100598	8.5%
	83901	7.1%
r	77632	6.5%
s	75861	6.4%
u	63166	5.3%
e	62314	5.2%
p	57905	4.9%
l	56870	4.8%
Other values (25)	274508	23.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1189346	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	191810	16.1%
o	144781	12.2%
i	100598	8.5%
	83901	7.1%
r	77632	6.5%
s	75861	6.4%
u	63166	5.3%
e	62314	5.2%
p	57905	4.9%
l	56870	4.8%
Other values (25)	274508	23.1%

geolocation_state
Categorical

High correlation Imbalance

Distinct	22
Distinct (%)	< 0.1%
Missing	1098
Missing (%)	0.9%
Memory size	6.7 MiB

SP	83572
MG	9424
PR	9212
RJ	5204
SC	4459
Other values (17)	6174

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	236090
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	MG
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	83572	70.1%
MG	9424	7.9%
PR	9212	7.7%
RJ	5204	4.4%
SC	4459	3.7%
RS	2298	1.9%
DF	908	0.8%
BA	704	0.6%
GO	550	0.5%
PE	465	0.4%
Other values (12)	1249	1.0%
(Missing)	1098	0.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	83572	70.8%
mg	9424	8.0%
pr	9212	7.8%
rj	5204	4.4%
sc	4459	3.8%
rs	2298	1.9%
df	908	0.8%
ba	704	0.6%
go	550	0.5%
pe	465	0.4%
Other values (12)	1249	1.1%

Most occurring characters

Value	Count	Frequency (%)
P	93305	39.5%
S	90790	38.5%
R	16782	7.1%
M	10044	4.3%
G	9974	4.2%
J	5204	2.2%
C	4563	1.9%
A	1118	0.5%
E	969	0.4%
D	908	0.4%
Other values (6)	2433	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	236090	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
P	93305	39.5%
S	90790	38.5%
R	16782	7.1%
M	10044	4.3%
G	9974	4.2%
J	5204	2.2%
C	4563	1.9%
A	1118	0.5%
E	969	0.4%
D	908	0.4%
Other values (6)	2433	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	236090	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
P	93305	39.5%
S	90790	38.5%
R	16782	7.1%
M	10044	4.3%
G	9974	4.2%
J	5204	2.2%
C	4563	1.9%
A	1118	0.5%
E	969	0.4%
D	908	0.4%
Other values (6)	2433	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	236090	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
P	93305	39.5%
S	90790	38.5%
R	16782	7.1%
M	10044	4.3%
G	9974	4.2%
J	5204	2.2%
C	4563	1.9%
A	1118	0.5%
E	969	0.4%
D	908	0.4%
Other values (6)	2433	1.0%

product_category_name_english
Text

Missing

Distinct	71
Distinct (%)	0.1%
Missing	2567
Missing (%)	2.2%
Memory size	7.9 MiB

Length

Max length	39
Median length	31
Mean length	12.988299
Min length	3

Characters and Unicode

Total characters	1514124
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	housewares
2nd row	housewares
3rd row	housewares
4th row	perfumery
5th row	auto

Value	Count	Frequency (%)
bed_bath_table	11988	10.3%
health_beauty	10032	8.6%
sports_leisure	9004	7.7%
furniture_decor	8832	7.6%
computers_accessories	8150	7.0%
housewares	7380	6.3%
watches_gifts	6213	5.3%
telephony	4726	4.1%
garden_tools	4590	3.9%
auto	4400	3.8%
Other values (61)	41261	35.4%

Most occurring characters

Value	Count	Frequency (%)
e	185298	12.2%
s	142057	9.4%
t	133341	8.8%
o	111892	7.4%
r	105808	7.0%
a	102466	6.8%
_	102216	6.8%
u	78227	5.2%
c	72479	4.8%
i	63331	4.2%
Other values (15)	417009	27.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1514124	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	185298	12.2%
s	142057	9.4%
t	133341	8.8%
o	111892	7.4%
r	105808	7.0%
a	102466	6.8%
_	102216	6.8%
u	78227	5.2%
c	72479	4.8%
i	63331	4.2%
Other values (15)	417009	27.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1514124	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	185298	12.2%
s	142057	9.4%
t	133341	8.8%
o	111892	7.4%
r	105808	7.0%
a	102466	6.8%
_	102216	6.8%
u	78227	5.2%
c	72479	4.8%
i	63331	4.2%
Other values (15)	417009	27.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1514124	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	185298	12.2%
s	142057	9.4%
t	133341	8.8%
o	111892	7.4%
r	105808	7.0%
a	102466	6.8%
_	102216	6.8%
u	78227	5.2%
c	72479	4.8%
i	63331	4.2%
Other values (15)	417009	27.5%

Interactions

Correlations

	customer_state	customer_zip_code_prefix	freight_value	geolocation_lat	geolocation_lng	geolocation_state	order_item_id	order_status	payment_installments	payment_sequential	payment_type	payment_value	price	product_description_lenght	product_height_cm	product_length_cm	product_name_lenght	product_photos_qty	product_weight_g	product_width_cm	review_score	seller_state	zip_code_prefix
customer_state	1.000	0.896	0.085	0.051	0.052	0.056	0.013	0.026	0.032	0.026	0.033	0.029	0.020	0.026	0.019	0.017	0.013	0.014	0.028	0.016	0.048	0.053	0.069
customer_zip_code_prefix	0.896	1.000	0.466	-0.003	-0.009	0.066	-0.009	0.022	0.069	-0.009	0.029	0.106	0.070	0.031	0.019	0.008	0.015	0.026	0.026	-0.002	0.041	0.065	0.060
freight_value	0.085	0.466	1.000	0.073	-0.065	0.048	-0.056	0.015	0.191	0.017	0.009	0.423	0.433	0.117	0.284	0.284	0.034	0.011	0.448	0.275	0.015	0.048	0.257
geolocation_lat	0.051	-0.003	0.073	1.000	0.045	0.754	0.012	0.008	0.043	0.011	0.018	0.063	0.065	-0.083	-0.009	0.035	-0.004	-0.131	0.073	0.096	0.013	0.750	0.273
geolocation_lng	0.052	-0.009	-0.065	0.045	1.000	0.882	-0.012	0.025	-0.032	-0.003	0.015	-0.045	-0.036	0.130	0.009	-0.069	-0.087	0.034	-0.074	-0.074	0.015	0.880	-0.406
geolocation_state	0.056	0.066	0.048	0.754	0.882	1.000	0.000	0.029	0.033	0.016	0.020	0.036	0.052	0.111	0.066	0.084	0.069	0.040	0.078	0.058	0.023	0.996	0.926
order_item_id	0.013	-0.009	-0.056	0.012	-0.012	0.000	1.000	0.002	0.061	-0.008	0.021	0.257	-0.116	-0.032	0.018	0.007	-0.021	-0.065	0.000	-0.004	0.041	0.000	-0.011
order_status	0.026	0.022	0.015	0.008	0.025	0.029	0.002	1.000	0.005	0.026	0.037	0.015	0.014	0.016	0.016	0.014	0.019	0.013	0.011	0.004	0.149	0.029	0.013
payment_installments	0.032	0.069	0.191	0.043	-0.032	0.033	0.061	0.005	1.000	-0.178	0.236	0.395	0.315	0.033	0.106	0.109	0.016	-0.003	0.198	0.125	0.027	0.033	0.065
payment_sequential	0.026	-0.009	0.017	0.011	-0.003	0.016	-0.008	0.026	-0.178	1.000	0.198	-0.215	-0.005	-0.013	0.013	0.034	-0.003	-0.005	0.030	0.028	0.012	0.016	0.007
payment_type	0.033	0.029	0.009	0.018	0.015	0.020	0.021	0.037	0.236	0.198	1.000	0.018	0.014	0.020	0.015	0.022	0.011	0.004	0.018	0.020	0.010	0.021	0.018
payment_value	0.029	0.106	0.423	0.063	-0.045	0.036	0.257	0.015	0.395	-0.215	0.018	1.000	0.789	0.169	0.305	0.229	0.025	-0.011	0.449	0.232	0.028	0.036	0.160
price	0.020	0.070	0.433	0.065	-0.036	0.052	-0.116	0.014	0.315	-0.005	0.014	0.789	1.000	0.211	0.327	0.266	0.042	0.029	0.514	0.271	0.012	0.052	0.175
product_description_lenght	0.026	0.031	0.117	-0.083	0.130	0.111	-0.032	0.016	0.033	-0.013	0.020	0.169	0.211	1.000	0.135	-0.021	0.073	0.111	0.095	-0.081	0.015	0.112	0.001
product_height_cm	0.019	0.019	0.284	-0.009	0.009	0.066	0.018	0.016	0.106	0.013	0.015	0.305	0.327	0.135	1.000	0.248	-0.057	-0.079	0.532	0.338	0.018	0.065	0.049
product_length_cm	0.017	0.008	0.284	0.035	-0.069	0.084	0.007	0.014	0.109	0.034	0.022	0.229	0.266	-0.021	0.248	1.000	0.060	0.005	0.619	0.632	0.018	0.084	0.067
product_name_lenght	0.013	0.015	0.034	-0.004	-0.087	0.069	-0.021	0.019	0.016	-0.003	0.011	0.025	0.042	0.073	-0.057	0.060	1.000	0.163	0.076	0.065	0.013	0.070	0.009
product_photos_qty	0.014	0.026	0.011	-0.131	0.034	0.040	-0.065	0.013	-0.003	-0.005	0.004	-0.011	0.029	0.111	-0.079	0.005	0.163	1.000	0.003	-0.015	0.016	0.040	-0.078
product_weight_g	0.028	0.026	0.448	0.073	-0.074	0.078	0.000	0.011	0.198	0.030	0.018	0.449	0.514	0.095	0.532	0.619	0.076	0.003	1.000	0.621	0.020	0.078	0.096
product_width_cm	0.016	-0.002	0.275	0.096	-0.074	0.058	-0.004	0.004	0.125	0.028	0.020	0.232	0.271	-0.081	0.338	0.632	0.065	-0.015	0.621	1.000	0.014	0.057	0.077
review_score	0.048	0.041	0.015	0.013	0.015	0.023	0.041	0.149	0.027	0.012	0.010	0.028	0.012	0.015	0.018	0.018	0.013	0.016	0.020	0.014	1.000	0.023	0.021
seller_state	0.053	0.065	0.048	0.750	0.880	0.996	0.000	0.029	0.033	0.016	0.021	0.036	0.052	0.112	0.065	0.084	0.070	0.040	0.078	0.057	0.023	1.000	0.920
zip_code_prefix	0.069	0.060	0.257	0.273	-0.406	0.926	-0.011	0.013	0.065	0.007	0.018	0.160	0.175	0.001	0.049	0.067	0.009	-0.078	0.096	0.077	0.021	0.920	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	order_id	customer_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	payment_sequential	payment_type	payment_installments	payment_value	review_id	review_score	review_comment_title	review_comment_message	review_creation_date	review_answer_timestamp	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	zip_code_prefix	seller_city	seller_state	geolocation_lat	geolocation_lng	geolocation_city	geolocation_state	product_category_name_english
0	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	1.0	credit_card	1.0	18.12	a54f0611adc9ed256b57ede6b6eb5114	4.0	NaN	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.	2017-10-11 00:00:00	2017-10-12 03:43:48	1.0	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	9350.0	maua	SP	-23.680114	-46.452454	maua	SP	housewares
1	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	3.0	voucher	1.0	2.00	a54f0611adc9ed256b57ede6b6eb5114	4.0	NaN	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.	2017-10-11 00:00:00	2017-10-12 03:43:48	1.0	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	9350.0	maua	SP	-23.680114	-46.452454	maua	SP	housewares
2	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	2.0	voucher	1.0	18.59	a54f0611adc9ed256b57ede6b6eb5114	4.0	NaN	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.	2017-10-11 00:00:00	2017-10-12 03:43:48	1.0	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	9350.0	maua	SP	-23.680114	-46.452454	maua	SP	housewares
3	53cdb2fc8bc7dce0b6741e2150273451	b0830fb4747a6c6d20dea0b8c802d7ef	delivered	2018-07-24 20:41:37	2018-07-26 03:24:27	2018-07-26 14:31:00	2018-08-07 15:27:45	2018-08-13 00:00:00	af07308b275d755c9edb36a90c618231	47813	barreiras	BA	1.0	boleto	1.0	141.46	8d5266042046a06655c8db133d120ba5	4.0	Muito boa a loja	Muito bom o produto.	2018-08-08 00:00:00	2018-08-08 18:37:50	1.0	595fac2a385ac33a80bd5114aec74eb8	289cdb325fb7e7f891c38608bf9e0962	2018-07-30 03:24:27	118.70	22.76	perfumaria	29.0	178.0	1.0	400.0	19.0	13.0	19.0	31570.0	belo horizonte	SP	-19.810119	-43.984727	belo horizonte	MG	perfumery
4	47770eb9100c2d0c44946d9cf07ec65d	41ce2a54c0b03bf3443c3d931a367089	delivered	2018-08-08 08:38:49	2018-08-08 08:55:23	2018-08-08 13:50:00	2018-08-17 18:06:29	2018-09-04 00:00:00	3a653a41f6f9fc3d2a113cf8398680e8	75265	vianopolis	GO	1.0	credit_card	3.0	179.12	e73b67b67587f7644d5bd1a52deb1b01	5.0	NaN	NaN	2018-08-18 00:00:00	2018-08-22 19:07:58	1.0	aa4383b373c6aca5d8797843e5594415	4869f7a5dfa277a7dca6462dcf3b52b2	2018-08-13 08:55:23	159.90	19.22	automotivo	46.0	232.0	1.0	420.0	24.0	19.0	21.0	14840.0	guariba	SP	-21.362358	-48.232976	guariba	SP	auto
5	949d5b44dbf5de918fe9c16f97b45f8a	f88197465ea7920adcdbec7375364d82	delivered	2017-11-18 19:28:06	2017-11-18 19:45:59	2017-11-22 13:39:59	2017-12-02 00:28:42	2017-12-15 00:00:00	7c142cf63193a1473d2e66489a9ae977	59296	sao goncalo do amarante	RN	1.0	credit_card	1.0	72.20	359d03e676b3c069f62cadba8dd3f6e8	5.0	NaN	O produto foi exatamente o que eu esperava e estava descrito no site e chegou bem antes da data prevista.	2017-12-03 00:00:00	2017-12-05 19:21:58	1.0	d0b61bfb1de832b15ba9d266ca96e5b0	66922902710d126a0e7d26b0e3805106	2017-11-23 19:45:59	45.00	27.20	pet_shop	59.0	468.0	3.0	450.0	30.0	10.0	20.0	31842.0	belo horizonte	MG	-19.840168	-43.923299	belo horizonte	MG	pet_shop
6	ad21c59c0840e6cb83a9ceb5573f8159	8ab97904e6daea8866dbdbc4fb7aad2c	delivered	2018-02-13 21:18:39	2018-02-13 22:20:29	2018-02-14 19:46:34	2018-02-16 18:17:02	2018-02-26 00:00:00	72632f0f9dd73dfee390c9b22eb56dd6	9195	santo andre	SP	1.0	credit_card	1.0	28.62	e50934924e227544ba8246aeb3770dd4	5.0	NaN	NaN	2018-02-17 00:00:00	2018-02-18 13:02:51	1.0	65266b2da20d04dbe00c5c2d3bb7859e	2c9e548be18521d1c43cde1c582c6de8	2018-02-19 20:31:37	19.90	8.72	papelaria	38.0	316.0	4.0	250.0	51.0	15.0	15.0	8752.0	mogi das cruzes	SP	-23.551707	-46.260979	mogi das cruzes	SP	stationery
7	a4591c265e18cb1dcee52889e2d8acc3	503740e9ca751ccdda7ba28e9ab8f608	delivered	2017-07-09 21:57:05	2017-07-09 22:10:13	2017-07-11 14:58:04	2017-07-26 10:57:55	2017-08-01 00:00:00	80bb27c7c16e8f973207a5086ab329e2	86320	congonhinhas	PR	1.0	credit_card	6.0	175.26	89b738e70a1ce346db29a20fb2910161	4.0	NaN	NaN	2017-07-27 00:00:00	2017-07-27 22:48:30	1.0	060cb19345d90064d1015407193c233d	8581055ce74af1daba164fdbd55a40de	2017-07-13 22:10:13	147.90	27.36	automotivo	49.0	608.0	1.0	7150.0	65.0	10.0	65.0	7112.0	guarulhos	SP	-23.465304	-46.511487	guarulhos	SP	auto
8	136cce7faa42fdb2cefd53fdc79a6098	ed0271e0b7da060a393796590e7b737a	invoiced	2017-04-11 12:22:08	2017-04-13 13:25:17	NaN	NaN	2017-05-09 00:00:00	36edbb3fb164b1f16485364b6fb04c73	98900	santa rosa	RS	1.0	credit_card	1.0	65.95	e07549ef5311abcc92ba1784b093fb56	2.0	NaN	fiquei triste por n ter me atendido.	2017-05-13 00:00:00	2017-05-13 20:25:42	1.0	a1804276d9941ac0733cfd409f5206eb	dc8798cbf453b7e0f98745e396cc5616	2017-04-19 13:25:17	49.90	16.05	NaN	NaN	NaN	NaN	600.0	35.0	35.0	15.0	5455.0	sao paulo	SP	-23.536892	-46.713111	sao paulo	SP	NaN
9	6514b8ad8028c9f2cc2374ded245783f	9bdf08b4b3b52b5526ff42d37d47f222	delivered	2017-05-16 13:10:30	2017-05-16 13:22:11	2017-05-22 10:07:46	2017-05-26 12:55:51	2017-06-07 00:00:00	932afa1e708222e5821dac9cd5db4cae	26525	nilopolis	RJ	1.0	credit_card	3.0	75.16	07d67dd06ed5f88bef11ef6b464e79ae	5.0	NaN	NaN	2017-05-27 00:00:00	2017-05-28 02:59:57	1.0	4520766ec412348b8d4caa5e8a18c464	16090f2ca825584b5a147ab24aa30c86	2017-05-22 13:22:11	59.99	15.17	automotivo	59.0	956.0	1.0	50.0	16.0	16.0	17.0	12940.0	atibaia	SP	-23.112774	-46.548885	atibaia	SP	auto

	order_id	customer_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	payment_sequential	payment_type	payment_installments	payment_value	review_id	review_score	review_comment_title	review_comment_message	review_creation_date	review_answer_timestamp	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	zip_code_prefix	seller_city	seller_state	geolocation_lat	geolocation_lng	geolocation_city	geolocation_state	product_category_name_english
119133	9115830be804184b91f5c00f6f49f92d	da2124f134f5dfbce9d06f29bdb6c308	delivered	2017-10-04 19:57:37	2017-10-04 20:07:14	2017-10-05 16:52:52	2017-10-20 20:25:45	2017-11-07 00:00:00	c716cf2b5b86fb24257cffe9e7969df8	78048	cuiaba	MT	2.0	voucher	1.0	64.37	ebd75732b5804e934123d11ec1f11db0	5.0	NaN	NaN	2017-10-21 00:00:00	2017-10-23 14:48:40	2.0	49d2e2460386273b195e7e59b43587c3	1caf283236cd69af44cbc09a0a1e7d32	2017-10-10 20:07:14	26.90	36.98	brinquedos	40.0	180.0	3.0	750.0	26.0	15.0	26.0	26020.0	nova iguacu	RJ	-22.741390	-43.447927	nova iguaçu	RJ	toys
119134	aa04ef5214580b06b10e2a378300db44	f01a6bfcc730456317e4081fe0c9940e	delivered	2017-01-27 00:30:03	2017-01-27 01:05:25	2017-01-30 11:40:16	2017-02-07 13:15:25	2017-03-17 00:00:00	e03dbdf5e56c96b106d8115ac336f47f	35502	divinopolis	MG	2.0	voucher	1.0	250.00	e8995c053d3db2d9c07407efe7de52dd	5.0	NaN	NaN	2017-02-08 00:00:00	2017-02-11 12:37:36	1.0	9fc063fd34fed29ccc57b7f8e8d03388	ccc4bbb5f32a6ab2b7066a4130f114e3	2017-02-03 00:30:03	370.00	19.43	beleza_saude	48.0	657.0	1.0	750.0	38.0	12.0	25.0	80310.0	curitiba	PR	-25.464029	-49.304728	curitiba	PR	health_beauty
119135	aa04ef5214580b06b10e2a378300db44	f01a6bfcc730456317e4081fe0c9940e	delivered	2017-01-27 00:30:03	2017-01-27 01:05:25	2017-01-30 11:40:16	2017-02-07 13:15:25	2017-03-17 00:00:00	e03dbdf5e56c96b106d8115ac336f47f	35502	divinopolis	MG	1.0	credit_card	5.0	139.43	e8995c053d3db2d9c07407efe7de52dd	5.0	NaN	NaN	2017-02-08 00:00:00	2017-02-11 12:37:36	1.0	9fc063fd34fed29ccc57b7f8e8d03388	ccc4bbb5f32a6ab2b7066a4130f114e3	2017-02-03 00:30:03	370.00	19.43	beleza_saude	48.0	657.0	1.0	750.0	38.0	12.0	25.0	80310.0	curitiba	PR	-25.464029	-49.304728	curitiba	PR	health_beauty
119136	880675dff2150932f1601e1c07eadeeb	47cd45a6ac7b9fb16537df2ccffeb5ac	delivered	2017-02-23 09:05:12	2017-02-23 09:15:11	2017-03-01 10:22:52	2017-03-06 11:08:08	2017-03-22 00:00:00	831ce3f1bacbd424fc4e38fbd4d66d29	5127	sao paulo	SP	1.0	credit_card	3.0	155.99	96e8f371a3983122b739944537e15525	5.0	NaN	NaN	2017-03-07 00:00:00	2017-03-11 15:42:41	1.0	ea73128566d1b082e5101ce46f8107c7	391fc6631aebcf3004804e51b40bcf1e	2017-02-27 09:05:12	139.90	16.09	moveis_decoracao	63.0	254.0	2.0	2500.0	49.0	13.0	41.0	14940.0	ibitinga	SP	-21.766477	-48.831547	ibitinga	SP	furniture_decor
119137	9c5dedf39a927c1b2549525ed64a053c	39bd1228ee8140590ac3aca26f2dfe00	delivered	2017-03-09 09:54:05	2017-03-09 09:54:05	2017-03-10 11:18:03	2017-03-17 15:08:01	2017-03-28 00:00:00	6359f309b166b0196dbf7ad2ac62bb5a	12209	sao jose dos campos	SP	1.0	credit_card	3.0	85.08	e262b3f92d1ce917aa412a9406cf61a6	5.0	NaN	NaN	2017-03-22 00:00:00	2017-03-23 11:02:08	1.0	ac35486adb7b02598c182c2ff2e05254	e24fc9fcd865784fb25705606fe3dfe7	2017-03-15 09:54:05	72.00	13.08	beleza_saude	50.0	1517.0	1.0	1175.0	22.0	13.0	18.0	12913.0	braganca paulista	SP	-22.957505	-46.524886	braganca paulista	SP	health_beauty
119138	63943bddc261676b46f01ca7ac2f7bd8	1fca14ff2861355f6e5f14306ff977a7	delivered	2018-02-06 12:58:58	2018-02-06 13:10:37	2018-02-07 23:22:42	2018-02-28 17:37:56	2018-03-02 00:00:00	da62f9e57a76d978d02ab5362c509660	11722	praia grande	SP	1.0	credit_card	3.0	195.00	29bb71b2760d0f876dfa178a76bc4734	4.0	NaN	So uma peça que veio rachado mas tudo bem rs	2018-03-01 00:00:00	2018-03-02 17:50:01	1.0	f1d4ce8c6dd66c47bbaa8c6781c2a923	1f9ab4708f3056ede07124aad39a2554	2018-02-12 13:10:37	174.90	20.10	bebes	52.0	828.0	4.0	4950.0	40.0	10.0	40.0	17602.0	tupa	SP	-21.935321	-50.497562	tupa	SP	baby
119139	83c1379a015df1e13d02aae0204711ab	1aa71eb042121263aafbe80c1b562c9c	delivered	2017-08-27 14:46:43	2017-08-27 15:04:16	2017-08-28 20:52:26	2017-09-21 11:24:17	2017-09-27 00:00:00	737520a9aad80b3fbbdad19b66b37b30	45920	nova vicosa	BA	1.0	credit_card	5.0	271.01	371579771219f6db2d830d50805977bb	5.0	NaN	Foi entregue antes do prazo.	2017-09-22 00:00:00	2017-09-22 23:10:57	1.0	b80910977a37536adeddd63663f916ad	d50d79cb34e38265a8649c383dcffd48	2017-09-05 15:04:16	205.99	65.02	eletrodomesticos_2	51.0	500.0	2.0	13300.0	32.0	90.0	22.0	8290.0	sao paulo	SP	-23.551013	-46.448489	sao paulo	SP	home_appliances_2
119140	11c177c8e97725db2631073c19f07b62	b331b74b18dc79bcdf6532d51e1637c1	delivered	2018-01-08 21:28:27	2018-01-08 21:36:21	2018-01-12 15:35:03	2018-01-25 23:32:54	2018-02-15 00:00:00	5097a5312c8b157bb7be58ae360ef43c	28685	japuiba	RJ	1.0	credit_card	4.0	441.16	8ab6855b9fe9b812cd03a480a25058a1	2.0	NaN	Foi entregue somente 1. Quero saber do outro produto.	2018-01-26 00:00:00	2018-01-27 09:16:56	1.0	d1c427060a0f73f6b889a5c7c61f2ac4	a1043bafd471dff536d0c462352beb48	2018-01-12 21:36:21	179.99	40.59	informatica_acessorios	59.0	1893.0	1.0	6550.0	20.0	20.0	20.0	37175.0	ilicinea	MG	-20.944706	-45.827098	ilicinea	MG	computers_accessories
119141	11c177c8e97725db2631073c19f07b62	b331b74b18dc79bcdf6532d51e1637c1	delivered	2018-01-08 21:28:27	2018-01-08 21:36:21	2018-01-12 15:35:03	2018-01-25 23:32:54	2018-02-15 00:00:00	5097a5312c8b157bb7be58ae360ef43c	28685	japuiba	RJ	1.0	credit_card	4.0	441.16	8ab6855b9fe9b812cd03a480a25058a1	2.0	NaN	Foi entregue somente 1. Quero saber do outro produto.	2018-01-26 00:00:00	2018-01-27 09:16:56	2.0	d1c427060a0f73f6b889a5c7c61f2ac4	a1043bafd471dff536d0c462352beb48	2018-01-12 21:36:21	179.99	40.59	informatica_acessorios	59.0	1893.0	1.0	6550.0	20.0	20.0	20.0	37175.0	ilicinea	MG	-20.944706	-45.827098	ilicinea	MG	computers_accessories
119142	66dea50a8b16d9b4dee7af250b4be1a5	edb027a75a1449115f6b43211ae02a24	delivered	2018-03-08 20:57:30	2018-03-09 11:20:28	2018-03-09 22:11:59	2018-03-16 13:08:30	2018-04-03 00:00:00	60350aa974b26ff12caad89e55993bd6	83750	lapa	PR	1.0	debit_card	1.0	86.86	dc9c59b4688062c25758c2be4cafc523	5.0	NaN	NaN	2018-03-17 00:00:00	2018-03-17 16:33:31	1.0	006619bbed68b000c8ba3f8725d5409e	ececbfcff9804a2d6b40f589df8eef2b	2018-03-15 10:55:42	68.50	18.36	beleza_saude	45.0	569.0	1.0	150.0	16.0	7.0	15.0	14407.0	franca	SP	-20.502342	-47.421590	franca	SP	health_beauty

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)